Today's Question:  What does your personal desk look like?        GIVE A SHOUT

SEARCH KEYWORD -- Local storage

  Why (offset, limit) is slow in database select?

Starting from a problem Five years ago when I was working at Tencent, I found that MySQL request speed was very slow in the pagination scenario. With only 100,000 data, a select query on a single machine took about 2-3 seconds. I asked my mentor why, and he asked in return, "In an indexing scenario, what is the time complexity to get the nth largest number in MySQL?" The pursuit of the answer Confirming the scenario Assuming there is an index on the "status" column, a query like "select * from t...

   SLOW,LIMIT,OFFSET,MYSQL     2023-03-12 05:21:02

  Fix SSL 'alert protocol version' issue while git clone remote repository

Git provides ways to securely connect to remote repository and clone remote repository to local machine. This post will teach you how to fix the "SSL23_GET_SERVER_HELLO:tlsv1 alert protocol version" issue while cloning a remote repository. The issue would look like: If this error occurs, it is most probably caused by out of date git version being used.To improve its security awareness, some weak cryptographic algorithms have been disabled and all git clients should upgrade to latest ones to acc...

   GIT,GIT CLONE,GIT SECURITY     2018-07-08 05:41:39

  10 Best Android Apps of 2016

The year 2016 has been gone with all its good and bad memories. But in the field of information technology, this year was another boost in which the field rapidly grew and explores some more essentials for the ease of users. In the field of mobile apps, specially users of Android OS, the year 2016 was awesome because in this year, they got many useful apps created by the highly qualified app developers of the world.Experts of Android OS rounded up a lot of apps created in the year 2016 and they ...

   MOBILE APP DEVELOPMENT COMPANY,CUSTOM MOBILE APP DEVELOPMENT COMPANY     2017-01-10 14:07:32

RECENT